TEXT: Concatenate
When the CONCATENATE Function opens, please edit the Function Arguments.
Text1 will be the Cells in Column J that have the first 3 letters of the months.
Text2 will be the comma and space between the Text1 and Text3.
5. Try it: Edit the CONCATENATE Function
Text1 select: J2.
Text2 type: ", "
Text3 select: C2.
Text4 type: ", "
Text5: Select Cell E2.
There will be a preview of the results:
Jan, Private, Cold Platter.
Click OK.
Do This, Too: Copy the LEFT Function
Select Cell J2 (This is the Cell with the CONCATENATE Function.)
Copy Cell K2 and paste the CONCATENATE Function into Cells K3:K69.
Keep going...
